<%@page contentType="text/html"%>
<%@page pageEncoding="UTF-8"%>
<%--
The taglib directive below imports the JSTL library. If you uncomment it,
you must also add the JSTL library to the project. The Add Library... action
on Libraries node in Projects view can be used to add the JSTL 1.1 library.
--%>
<%--
<%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%> 
--%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
   "http://www.w3.org/TR/html4/loose.dtd">

<jsp:useBean id="actions" scope="application" class="DataAccess.Actions"/>
<%
//utenti.setConnectionString("jdbc:microsoft:sqlserver://ormt189:1433;DatabaseName=ariellab;user=test;password=test");

//articolo.setDriverString("com.microsoft.jdbc.sqlserver.SQLServerDriver");
//articolo.setConnectionString("jdbc:microsoft:sqlserver://ormt189:1433;DatabaseName=ariellab;user=test;password=test");
actions.setDriverString("com.mysql.jdbc.Driver");
actions.setConnectionString("jdbc:mysql://127.0.0.1/carta?user=root&password=");
//actions.setConnectionString("jdbc:mysql://127.0.0.1/andreafortuna?user=andreafortuna&password=asturias");
//Integer id_articolo = request.getParameter("id_articolo");

//String id_action=request.getParameter("action");
String id_stato = request.getParameter("id_stato");
%>

<%=actions.getTableFromQuery("select regioni.id_regione as ID,regioni.nome_regione as regione ,stati.nome_stato as Stato from stati, regioni where regioni.id_stato=stati.id_stato and regioni.id_stato = " +  id_stato ,"ID", "index.jsp?action=modifica_regione&operazione=modifica&id_regione=", "index.jsp?action=modifica_regione&operazione=elimina&id_regione=")%>